NTISthis.com

Evidence Guide: ICTDBS402 - Complete database backup and restore

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTDBS402 - Complete database backup and restore

What evidence can you provide to prove your understanding of each of the following citeria?

Review the database architecture to plan backup and recovery

  1. Examine the architecture of a database file system
  2. Determine the most appropriate methods for backup and recovery
  3. Identify and examine the likely or possible risk and failure scenarios
  4. Prepare a backup maintenance schedule
  5. Prepare a contingency plan
Examine the architecture of a database file system

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine the most appropriate methods for backup and recovery

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify and examine the likely or possible risk and failure scenarios

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Prepare a backup maintenance schedule

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Prepare a contingency plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine backup methods appropriate to database requirements

  1. Evaluate the range of backup and restoration methods, based on organisational and security standards, and on the assessment of likely, or possible, failure scenarios
  2. Complete full off-line backups according to organisational and security standards, with minimal down time
  3. Complete online file backups, as determined by organisational and security standards, with minimal down time
  4. Employ disk mirroring and redundant array of inexpensive disks (RAID) hard disk configurations to keep copies of files
  5. Arrange off-site copies of backup files
Evaluate the range of backup and restoration methods, based on organisational and security standards, and on the assessment of likely, or possible, failure scenarios

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Complete full off-line backups according to organisational and security standards, with minimal down time

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Complete online file backups, as determined by organisational and security standards, with minimal down time

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Employ disk mirroring and redundant array of inexpensive disks (RAID) hard disk configurations to keep copies of files

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Arrange off-site copies of backup files

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Establish recovery points and disaster-recovery procedures

  1. Determine database recovery points based on the backup arrangements, according to organisational guidelines
  2. Test the restore process to ensure that the database can be restored to a given recovery point, with minimal down time
  3. Complete the restoration of the database to the point of failure, without loss of committed transactions
Determine database recovery points based on the backup arrangements, according to organisational guidelines

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test the restore process to ensure that the database can be restored to a given recovery point, with minimal down time

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Complete the restoration of the database to the point of failure, without loss of committed transactions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and deploy a standby database

  1. Create or set up a standby database, in order to meet organisational guidelines
  2. Implement a standby database to support critical business functions
  3. Prepare the documentation for a standby database
Create or set up a standby database, in order to meet organisational guidelines

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Implement a standby database to support critical business functions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Prepare the documentation for a standby database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Review the database architecture to plan backup and recovery

1.1 Examine the architecture of a database file system

1.2 Determine the most appropriate methods for backup and recovery

1.3 Identify and examine the likely or possible risk and failure scenarios

1.4 Prepare a backup maintenance schedule

1.5 Prepare a contingency plan

2. Determine backup methods appropriate to database requirements

2.1 Evaluate the range of backup and restoration methods, based on organisational and security standards, and on the assessment of likely, or possible, failure scenarios

2.2 Complete full off-line backups according to organisational and security standards, with minimal down time

2.3 Complete online file backups, as determined by organisational and security standards, with minimal down time

2.4 Employ disk mirroring and redundant array of inexpensive disks (RAID) hard disk configurations to keep copies of files

2.5 Arrange off-site copies of backup files

3. Establish recovery points and disaster-recovery procedures

3.1 Determine database recovery points based on the backup arrangements, according to organisational guidelines

3.2 Test the restore process to ensure that the database can be restored to a given recovery point, with minimal down time

3.3 Complete the restoration of the database to the point of failure, without loss of committed transactions

4. Create and deploy a standby database

4.1 Create or set up a standby database, in order to meet organisational guidelines

4.2 Implement a standby database to support critical business functions

4.3 Prepare the documentation for a standby database

Required Skills and Knowledge

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Review the database architecture to plan backup and recovery

1.1 Examine the architecture of a database file system

1.2 Determine the most appropriate methods for backup and recovery

1.3 Identify and examine the likely or possible risk and failure scenarios

1.4 Prepare a backup maintenance schedule

1.5 Prepare a contingency plan

2. Determine backup methods appropriate to database requirements

2.1 Evaluate the range of backup and restoration methods, based on organisational and security standards, and on the assessment of likely, or possible, failure scenarios

2.2 Complete full off-line backups according to organisational and security standards, with minimal down time

2.3 Complete online file backups, as determined by organisational and security standards, with minimal down time

2.4 Employ disk mirroring and redundant array of inexpensive disks (RAID) hard disk configurations to keep copies of files

2.5 Arrange off-site copies of backup files

3. Establish recovery points and disaster-recovery procedures

3.1 Determine database recovery points based on the backup arrangements, according to organisational guidelines

3.2 Test the restore process to ensure that the database can be restored to a given recovery point, with minimal down time

3.3 Complete the restoration of the database to the point of failure, without loss of committed transactions

4. Create and deploy a standby database

4.1 Create or set up a standby database, in order to meet organisational guidelines

4.2 Implement a standby database to support critical business functions

4.3 Prepare the documentation for a standby database

Evidence of the ability to:

determine and prepare the appropriate methods for backup, maintenance and recovery, including a contingency plan

implement the backup and restore procedures, with minimum disruption to the business

create, implement and document a standby database.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

explain the basic principles of:

diagnostic tools

structured query language (SQL)

databases

tuning methodologies

outline and apply the principles of:

backup and recovery methods

database administration

database security

open file backup procedures and restore operations.